package com.ocom.payconfig.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ocom.common.entity.card.EntityXfDeviceInfo;
import com.ocom.common.response.DeviceCcbPosListResponse;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface IDaoXfDeviceInfo extends BaseMapper<EntityXfDeviceInfo> {
    @Select({"<script>",
            "SELECT  D.device_no , C.bind_merch_id \n" +
                    " FROM  xf_device_info AS D \n" +
                    " LEFT JOIN ccb_pos_info AS C ON C.device_no = D.device_no \n" +
                    " WHERE  D.com_id = #{comId} AND D.point_id = #{pointId}"+
                    "</script>"})
    List<DeviceCcbPosListResponse> getDeviceccbPos(Long comId,Integer pointId);
}
